Insert

Insert

@Autowired  
private NamedParameterJdbcTemplate namedParameterJdbcTemplate;  
// SpringJDBC已經自動創建好bean了 直接autowired使用
@PostMapping("/students")  
// ResponseBody註解自動把request的json轉換成pojo
public String create(@RequestBody Student student) {  
    HashMap<String, Object> map = new HashMap<>();  
    //這邊value內冒號的寫法 jdbctemplate會把他當作key到map中取值後來當作sql參數  
    String sql = "Insert into student(id,name) VALUE (:studentId,:studentName)";  
    //我們要根據key來建立我們希望sql放入的值 key-value = 上面的key名稱-我們希望的值（前端送入的值）  
    map.put("studentId", student.getAge());  
    map.put("studentName", student.getName());  
    namedParameterJdbcTemplate.update(sql,map);  
    return "create...";  
}

public class Student {  
    private int id;  
    private String name;  
    
    public Student() {  
    }  
    public Student(int id, String name) {  
        this.id = id;  
        this.name = name;  
    }
    //......getter & setter